UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8F1VnOkyz93+G8W+ja76/0WUCRr7bNGzlCpd4CFPjg='
WHERE
key_id = 'a06e1bba053435e245b0a0aa42905a5c1b80304f07e552395a9f4257c5ba8451'
AND (
token = 'H8F1VnOkyz93+G8W+ja76/0WUCRr7bNGzlCpd4CFPjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)