UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDaVcE0Faezip5TXFREgQaQAe+jbo7PEdNM8zWWkNH4='
WHERE
key_id = '7cac6771d92da8a3cfdb086b5ebe023717fdd94497c3af3acbbd3359c2884ded'
AND (
token = 'HDaVcE0Faezip5TXFREgQaQAe+jbo7PEdNM8zWWkNH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)