UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MFempAQfW+7Z2elTfP4eZ3l9W921Nac0NBn/vFXaopI='
WHERE
key_id = 'fc788359003f3231a484e3225ec6ad5f8fdfb0f0a12eb1afeea02d3a2a46a50f'
AND (
token = 'MFempAQfW+7Z2elTfP4eZ3l9W921Nac0NBn/vFXaopI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)