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