UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FVkJKR9R11s8yLXsatcCodV6wVhZN2ZuzDJE2vk8fc0='
WHERE
key_id = '7912efa2b4535f047c1b43104ee24cbbcd8ae5813632bae4b592abc91945f6f7'
AND (
token = 'FVkJKR9R11s8yLXsatcCodV6wVhZN2ZuzDJE2vk8fc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)