UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zJRykOzkqPq+ME9kLKd1K15rLtBaQ+jrfGHKvvYHuM='
WHERE
key_id = 'b8b2e009d49bebefd3d8026df5fab7daf30bd78fe01ecece3fb99ff92f17f1b9'
AND (
token = '8zJRykOzkqPq+ME9kLKd1K15rLtBaQ+jrfGHKvvYHuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)