UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pef46d3NiDuUW/DwM13IUC2DdpRSmFxrGsTwpzzY8lk='
WHERE
key_id = 'd46b27843563f597cde0b8a0a83e631180179e0cc63f2a35d9f547a6707831d3'
AND (
token = 'pef46d3NiDuUW/DwM13IUC2DdpRSmFxrGsTwpzzY8lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)