UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zQuS9MS1Tn33yAIcJEAxi1stl9IcGeP2NhFOz1PyI0='
WHERE
key_id = 'ed2e448c211521758d6d9d5124b8107556c762ceebaac5ca03b6c5499d546a7a'
AND (
token = '5zQuS9MS1Tn33yAIcJEAxi1stl9IcGeP2NhFOz1PyI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)