UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9JOhcvZjZdQFW25k03xyG2/My/1OsFnQREcGgFo58o='
WHERE
key_id = '55918b7a61c613378aef251bf283f5570dcc0f7144aee6addeba083d4897c8e1'
AND (
token = 'a9JOhcvZjZdQFW25k03xyG2/My/1OsFnQREcGgFo58o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)