UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gpqRYaV3qwsLP9oEmx5zR9pIEGWFR87ew02aV/siydg='
WHERE
key_id = '9920d523422d3315d4aa67c08817379da43e2b5345ddb1ae2d6b28498502761f'
AND (
token = 'gpqRYaV3qwsLP9oEmx5zR9pIEGWFR87ew02aV/siydg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)