UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9bh94lqhCImqAk1h0AA7arv4oBUNUd5hf1u3N4gZt4='
WHERE
key_id = '4372c46bf7d10603e94f05c92fb89bc8d1e9449afe1cd756f1f744caa7cb1370'
AND (
token = 'D9bh94lqhCImqAk1h0AA7arv4oBUNUd5hf1u3N4gZt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)