UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPsxvwKsWEbkUTsn3iYYgc8NIhlPlcsDMCZenPlm+gw='
WHERE
key_id = 'df71292d8faa5e6662fc63f743cc42e112a4c01fa8996b459225fbc4ce1b3c0f'
AND (
token = 'pPsxvwKsWEbkUTsn3iYYgc8NIhlPlcsDMCZenPlm+gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)