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