UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3/+RVG6FKOP8wUL0R/7xhObC0NKBEpVzazB8WgDN6WE='
WHERE
key_id = 'f1712681f3da920aa380687f9497c4ffcf66c81a4bb42a901991a1cf823d9978'
AND (
token = '3/+RVG6FKOP8wUL0R/7xhObC0NKBEpVzazB8WgDN6WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)