UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgZ1hO58Aj9iCGBnDfQIWpZCS1z7N4gPPYlogNUi8IA='
WHERE
key_id = '522efb559851986937a2a38cd927856cd3bff3ef39bb7e793294074d8f2321ae'
AND (
token = 'KgZ1hO58Aj9iCGBnDfQIWpZCS1z7N4gPPYlogNUi8IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)