UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFF7o8EmpA45oNu2IRKu8BuikgzWpSyNd0GXMs6TsZM='
WHERE
key_id = '24fa74179be27cb045ff8abf493a4ecb9524a4aed82b27de9c1a34887f837403'
AND (
token = 'oFF7o8EmpA45oNu2IRKu8BuikgzWpSyNd0GXMs6TsZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)