UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xD3fVq4nERMtpknv8PBn8KSG4atFaD/6dqHbIpW53MU='
WHERE
key_id = '4a4753d8c952fe90af14ed8192d9b112be0d5cd2068f222ccb5f4a9065858c25'
AND (
token = 'xD3fVq4nERMtpknv8PBn8KSG4atFaD/6dqHbIpW53MU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)