UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YmrTB6QMWQ6oqL/Kt0sqOM73E5e1CaJPvmdTNH4ELL8='
WHERE
key_id = 'e4532fbebcf60749a26819b8ada36d17a4b9890c6f7a124a3cd246cb64cbcd11'
AND (
token = 'YmrTB6QMWQ6oqL/Kt0sqOM73E5e1CaJPvmdTNH4ELL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)