UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '006T7JK3UNUCPqKSAimT0ugF2h6AXXwv2v1cTQONfMw='
WHERE
key_id = 'e139c62661339ae2beeeaaa4e740782a8063afa566bb201b72a1e3cfe6fb3266'
AND (
token = '006T7JK3UNUCPqKSAimT0ugF2h6AXXwv2v1cTQONfMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)