UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YI8l0TYWz8YkTDgVbbugl1Zcsq2mDXd9GdsbBlavmN4='
WHERE
key_id = 'd97c0b2381cd1458c1383d498e3a423ca0b0d8c0b3e7df94390a8986deaf8555'
AND (
token = 'YI8l0TYWz8YkTDgVbbugl1Zcsq2mDXd9GdsbBlavmN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)