UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3owI5EvWBlwnser+qNo9ILuzxK7DHr5lbjxNCvqAeMA='
WHERE
key_id = 'c1fb49e8fb3f224f5bb0a1787ee832de6a0ed58cfddd76d5e954b8b92c775499'
AND (
token = '3owI5EvWBlwnser+qNo9ILuzxK7DHr5lbjxNCvqAeMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)