UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLfccd6QSr6yRag3Yy9RsvZVsBQjRwSeh8lep8QWCBA='
WHERE
key_id = 'da72b1f771a6cd09f121981e31895ee815c46de3f8a150942659d2d117a36cc6'
AND (
token = 'JLfccd6QSr6yRag3Yy9RsvZVsBQjRwSeh8lep8QWCBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)