UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mx3BhRZaHEsVawsDcfqIxIH30qax664uQ7pWRp5I4hU='
WHERE
key_id = '0bc3f15a85d94329df9f9681f5ed95a7e2a66ea7949683ba57a5ccb7de7c2407'
AND (
token = 'Mx3BhRZaHEsVawsDcfqIxIH30qax664uQ7pWRp5I4hU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)