UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DqFlv+rcvJLIj31Zw9JbJ84D12nCUpZ4b6Q6r1+nqWo='
WHERE
key_id = 'd6bede8bc1d1865ddb7d946add3f481778e87a9937a160fc2599b61a7b728bbc'
AND (
token = 'DqFlv+rcvJLIj31Zw9JbJ84D12nCUpZ4b6Q6r1+nqWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)