UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hG6yPhTzBhKKG1THSB2KyQLVKzYBv5eaFESEp9U+/Dc='
WHERE
key_id = '7fd11f2faf406b4934f0088c2ab60f8909ca175de12facd739df603afd70ef8b'
AND (
token = 'hG6yPhTzBhKKG1THSB2KyQLVKzYBv5eaFESEp9U+/Dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)