UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Q3NgeV4lN7E/FRDC9LtpX8sPnVWuovnzGmJB7u6pBk='
WHERE
key_id = '9727e95578a53253648b827a599fb0dd2e69120b11ee222f13bff844241e3285'
AND (
token = '/Q3NgeV4lN7E/FRDC9LtpX8sPnVWuovnzGmJB7u6pBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)