UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ncjs83JRUZlbVf+bh2Kl94rD/+30RzBOhnS+S5rbwuI='
WHERE
key_id = '4fd7e0d8c57d879caf208132c12c9c2657bde52c0404d737f68c0382dd649464'
AND (
token = 'Ncjs83JRUZlbVf+bh2Kl94rD/+30RzBOhnS+S5rbwuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)