UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRyz+oddmhiBjMfS9l5m/4anWWUq44WlyLyRwO2PkeI='
WHERE
key_id = '1a27bafb5fa155c89e627c3059fd64d8a56de929d77fd8926d854ba349ef7e45'
AND (
token = 'XRyz+oddmhiBjMfS9l5m/4anWWUq44WlyLyRwO2PkeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)