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