UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pG0pYIV2dv4LypQnYB/DsjPyWkuONqkhwwUsqV5YrZs='
WHERE
key_id = 'a1e132756c69326a46890cb504e8397611ecdd3a8ad851b530b3c083b22e3389'
AND (
token = 'pG0pYIV2dv4LypQnYB/DsjPyWkuONqkhwwUsqV5YrZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)