UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nz/cp9vUwqz6uHswN6gIxnSN28cW7GZXgvXO1cc5Qk8='
WHERE
key_id = 'ae379971e0e2e0bc8ec1a7c4c81bc3eb6e1d4443e86a8f444d27373d49d69728'
AND (
token = 'Nz/cp9vUwqz6uHswN6gIxnSN28cW7GZXgvXO1cc5Qk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)