UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2nTwpaqp740XtenPpZ3P8vuc1aMtdmM/ONCA+0AIHj4='
WHERE
key_id = 'a12d129794f405d61431ff9dd691332a13fafdd57896b1f94542eb4b3a3caf7a'
AND (
token = '2nTwpaqp740XtenPpZ3P8vuc1aMtdmM/ONCA+0AIHj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)