UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L8Ha+e2LhN+w4EJfzHLFSFdNojqqDc2eSXn+EG3oAGY='
WHERE
key_id = 'a823338ae797819fe4b4f591840fb37fb6d11feb12a35d377f8792ff3d0d2245'
AND (
token = 'L8Ha+e2LhN+w4EJfzHLFSFdNojqqDc2eSXn+EG3oAGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)