UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZMjrLbpnIXoj5hf3NAjBHZ0N+FLCMsrCcEuBYdM2H8='
WHERE
key_id = '7af79be04c94f270c62079c8c5ff61d6e30b1539d57c65ae58e84180963d0ce7'
AND (
token = '8ZMjrLbpnIXoj5hf3NAjBHZ0N+FLCMsrCcEuBYdM2H8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)