UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZs+tAR4UVy1egb0U4bqlIkoZlaeHlV5R98Ykex9cic='
WHERE
key_id = 'c69902afececc98a39fabf5b931152a65823166b7c6e1896a128dd98275cb307'
AND (
token = 'gZs+tAR4UVy1egb0U4bqlIkoZlaeHlV5R98Ykex9cic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)