UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVZG0ZKsoLmAG4D3EGjxGawqkYiGNwAPxd549QiihrQ='
WHERE
key_id = '8a4f38e3e8304de0544826aba3ed2d006c9643f3d78c9c24a816b7a59a133fd0'
AND (
token = 'VVZG0ZKsoLmAG4D3EGjxGawqkYiGNwAPxd549QiihrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)