UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNcv9/sxX6L6hVRe3UjezzE0oq13Kvct3fUyBFq7or4='
WHERE
key_id = '71c8b720fb2be53f1ad716e857ccd2d0d09e52e24273efdb129735ecfc807e74'
AND (
token = 'kNcv9/sxX6L6hVRe3UjezzE0oq13Kvct3fUyBFq7or4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)