UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5jfK2Qz0lcmc375R1eOvQPwY5tTHht+wtLyiyjn4Mk='
WHERE
key_id = 'e4fda9f2470325c5591eca3ceaec09538265618a244fa6b8228a873e24901d3b'
AND (
token = 'G5jfK2Qz0lcmc375R1eOvQPwY5tTHht+wtLyiyjn4Mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)